List of things to be done

April 25

• Set up PowerBI and restore data in the PostgreSQL database
  • Some issue with timescaledb and setting authorization
  • Figured out the issue with restoring postgres backup
• Migrate the database to sqlite
• Recreate the graphs created in the PowerBI
  • The plan is not to recreate all the graphs from PowerBI into the app
• Create the graphs using plotly
• Create the scenario table and add it in the sqlite database
• Create a view to see the scenario table
  • 2 tables, run id and status and run id with other parameters
  • Issue with foreign keys in sqlite needs to be fixed and discussed
• Replace the matplotlib graphs with plotly express
• Comparison of plotly express vs plotly graph objects
  • From the official documentation, Every Plotly Express function uses graph objects internally and returns a plotly.graph_objects.
• TigerGraph gallery is open

---

April 26

• Write unnormalized (raw) files to the db
• Exploring the possibility of transfer learning
  • Train on one utility, use on the other
• saving and exporting the models
• graphs for performance

April 29

• Migrate the arff files into the sqlite db
• Change plots of other utilities from matplotlib to plotly